DROP USER MAPPING
DROP USER MAPPING — Remove a user mapping for a foreign server
Synopsis
DROP USER MAPPING [ IF EXISTS ] FOR { user_name | USER | CURRENT_USER | PUBLIC }
SERVER server_name
Description
DROP USER MAPPING removes an existing user mapping from a foreign server.
The owner of a foreign server can drop user mappings for any user on that server. Also, if USAGE privilege on the server has been granted to a user, they can also drop a user mapping for their own user name.
Parameters
IF EXISTS
Do not throw an error if the user mapping does not exist. A notice is issued in this case.
user_name
The user name of the mapping. CURRENT_USER and USER match the name of the current user. PUBLIC is used to match all present and future user names in the system.
server_name
The server name of the user mapping.
Examples
# Drop the user mapping bob for server foo, if it exists:
DROP USER MAPPING IF EXISTS FOR bob SERVER foo;